import pymysql
import urllib.request
import json
from datetime import date, datetime, timedelta

db = pymysql.connect("114.115.160.16", "root", "123456Aa!", "fund")
cursor = db.cursor()

tables = ["api_check", "api_click", "api_follow", "api_fundvector", "api_hold", "api_preference",
"api_preferencevector", "api_queue", "api_remind", "api_timing", "api_user", "api_userfundscore"]

for table in tables:
    sql = "delete from " + table
    cursor.execute(sql)
    db.commit()
